Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	26148
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.0 MiB
Average record size in memory	401.5 B

Variable types

NUM	12
CAT	8

Reproduction

Analysis started	2022-12-10 15:39:12.572827
Analysis finished	2022-12-10 15:39:45.121895
Duration	32.55 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`Year` has constant value "2016"	Constant
`Data` has a high cardinality: 118 distinct values	High cardinality
`Time` has a high cardinality: 7675 distinct values	High cardinality
`TimeSunRise` has a high cardinality: 51 distinct values	High cardinality
`TimeSunSet` has a high cardinality: 56 distinct values	High cardinality
`SunPerDay` has a high cardinality: 75 distinct values	High cardinality
`Month` is highly correlated with `Id` and 1 other fields	High correlation
`Id` is highly correlated with `Month`	High correlation
`UNIXTime` is highly correlated with `Month`	High correlation
`Month` is highly correlated with `TimeSunRise` and 1 other fields	High correlation
`TimeSunRise` is highly correlated with `Month` and 1 other fields	High correlation
`SunPerDay` is highly correlated with `TimeSunSet` and 2 other fields	High correlation
`TimeSunSet` is highly correlated with `SunPerDay` and 1 other fields	High correlation
`SunPerDayHours` is highly correlated with `TimeSunRise` and 2 other fields	High correlation
`Id` is uniformly distributed	Uniform
`Id` has unique values	Unique
`UNIXTime` has unique values	Unique
`Speed` has 375 (1.4%) zeros	Zeros
`Hour` has 1003 (3.8%) zeros	Zeros
`Minute` has 2158 (8.3%) zeros	Zeros

Id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct count	26148
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16337.57866758452
Minimum	0
Maximum	32685
Zeros	1
Zeros (%)	< 0.1%
Memory size	204.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1608.35
Q1	8125.75
median	16379
Q3	24507.25
95-th percentile	31048.65
Maximum	32685
Range	32685
Interquartile range (IQR)	16381.5

Descriptive statistics

Standard deviation	9449.975676
Coefficient of variation (CV)	0.5784195974
Kurtosis	-1.202139245
Mean	16337.57867
Median Absolute Deviation (MAD)	8190.5
Skewness	-0.002733428249
Sum	427195007
Variance	89302040.28

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4152	1	< 0.1%
32190	1	< 0.1%
10875	1	< 0.1%
11572	1	< 0.1%
739	1	< 0.1%
1545	1	< 0.1%
9327	1	< 0.1%
5127	1	< 0.1%
24546	1	< 0.1%
23004	1	< 0.1%
Other values (26138)	26138	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
32685	1	< 0.1%
32684	1	< 0.1%
32682	1	< 0.1%
32681	1	< 0.1%
32680	1	< 0.1%

UNIXTime
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	26148
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1478046152.704528
Minimum	1472724008
Maximum	1483264501
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	1472724008
5-th percentile	1473229431
Q1	1475532770
median	1478038068
Q3	1480478477
95-th percentile	1482765838
Maximum	1483264501
Range	10540493
Interquartile range (IQR)	4945706.5

Descriptive statistics

Standard deviation	3005884.635
Coefficient of variation (CV)	0.00203368794
Kurtosis	-1.142572373
Mean	1478046153
Median Absolute Deviation (MAD)	2501998.5
Skewness	0.006375119015
Sum	3.86479508e+13
Variance	9.035342439e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1473879005	1	< 0.1%
1480734907	1	< 0.1%
1476954020	1	< 0.1%
1476744921	1	< 0.1%
1475004321	1	< 0.1%
1474752322	1	< 0.1%
1477419918	1	< 0.1%
1473579921	1	< 0.1%
1483257301	1	< 0.1%
1478451005	1	< 0.1%
Other values (26138)	26138	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1472724008	1	< 0.1%
1472724310	1	< 0.1%
1472725505	1	< 0.1%
1472725809	1	< 0.1%
1472726704	1	< 0.1%

Value	Count	Frequency (%)
1483264501	1	< 0.1%
1483264203	1	< 0.1%
1483263904	1	< 0.1%
1483263601	1	< 0.1%
1483263302	1	< 0.1%

Data
Categorical

HIGH CARDINALITY

Distinct count	118
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

9/23/2016 12:00:00 AM	245
10/27/2016 12:00:00 AM	243
11/18/2016 12:00:00 AM	242
11/3/2016 12:00:00 AM	241
11/19/2016 12:00:00 AM	240
Other values (113)	24937

Value	Count	Frequency (%)
9/23/2016 12:00:00 AM	245	0.9%
10/27/2016 12:00:00 AM	243	0.9%
11/18/2016 12:00:00 AM	242	0.9%
11/3/2016 12:00:00 AM	241	0.9%
11/19/2016 12:00:00 AM	240	0.9%
12/16/2016 12:00:00 AM	239	0.9%
12/23/2016 12:00:00 AM	239	0.9%
12/19/2016 12:00:00 AM	239	0.9%
12/2/2016 12:00:00 AM	238	0.9%
9/29/2016 12:00:00 AM	238	0.9%
Other values (108)	23744	90.8%

Length

Max length	22
Mean length	21.49395747
Min length	20

Value	Count	Frequency (%)
Decimal_Number	10	66.7%
Other_Punctuation	2	13.3%
Uppercase_Letter	2	13.3%
Space_Separator	1	6.7%

Value	Count	Frequency (%)
Common	13	86.7%
Latin	2	13.3%

Value	Count	Frequency (%)
ASCII	15	100.0%

Time
Categorical

HIGH CARDINALITY

Distinct count	7675
Unique (%)	29.4%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

02:05:02	18
06:05:18	18
12:25:18	17
09:05:18	17
03:45:18	17
Other values (7670)	26061

Value	Count	Frequency (%)
02:05:02	18	0.1%
06:05:18	18	0.1%
12:25:18	17	0.1%
09:05:18	17	0.1%
03:45:18	17	0.1%
12:45:18	17	0.1%
20:05:18	17	0.1%
08:30:18	16	0.1%
20:35:18	16	0.1%
14:55:18	16	0.1%
Other values (7665)	25979	99.4%

Length

Max length	8
Mean length	8
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

Temperature
Real number (ℝ_≥0)

Distinct count	38
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	51.1048646167967
Minimum	34
Maximum	71
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	34
5-th percentile	43
Q1	46
median	50
Q3	55
95-th percentile	63
Maximum	71
Range	37
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.213912409
Coefficient of variation (CV)	0.1215914073
Kurtosis	-0.3191962441
Mean	51.10486462
Median Absolute Deviation (MAD)	4
Skewness	0.5176414002
Sum	1336290
Variance	38.61270743

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
45	2358	9.0%
48	2085	8.0%
47	2027	7.8%
46	1706	6.5%
50	1658	6.3%
49	1610	6.2%
51	1543	5.9%
52	1218	4.7%
53	1071	4.1%
54	1011	3.9%
Other values (28)	9861	37.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
34	1	< 0.1%
35	7	< 0.1%
36	36	0.1%
37	79	0.3%
38	81	0.3%

Value	Count	Frequency (%)
71	13	< 0.1%
70	33	0.1%
69	30	0.1%
68	44	0.2%
67	69	0.3%

Pressure
Real number (ℝ_≥0)

Distinct count	38
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	30.42283501606241
Minimum	30.19
Maximum	30.56
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	30.19
5-th percentile	30.3
Q1	30.4
median	30.43
Q3	30.46
95-th percentile	30.49
Maximum	30.56
Range	0.37
Interquartile range (IQR)	0.06

Descriptive statistics

Standard deviation	0.05472382402
Coefficient of variation (CV)	0.001798774637
Kurtosis	2.119855824
Mean	30.42283502
Median Absolute Deviation (MAD)	0.03
Skewness	-1.235212722
Sum	795496.29
Variance	0.002994696916

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
30.44	2652	10.1%
30.43	2525	9.7%
30.45	2449	9.4%
30.42	2304	8.8%
30.46	2164	8.3%
30.41	1872	7.2%
30.47	1837	7.0%
30.4	1593	6.1%
30.48	1299	5.0%
30.39	1183	4.5%
Other values (28)	6270	24.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
30.19	13	< 0.1%
30.2	33	0.1%
30.21	39	0.1%
30.22	36	0.1%
30.23	65	0.2%

Value	Count	Frequency (%)
30.56	26	0.1%
30.55	23	0.1%
30.54	65	0.2%
30.53	43	0.2%
30.52	151	0.6%

Humidity
Real number (ℝ_≥0)

Distinct count	93
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	75.00523940645556
Minimum	11
Maximum	103
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	11
5-th percentile	25
Q1	56
median	85
Q3	97
95-th percentile	102
Maximum	103
Range	92
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	25.9931019
Coefficient of variation (CV)	0.3465504824
Kurtosis	-0.7543674338
Mean	75.00523941
Median Absolute Deviation (MAD)	15
Skewness	-0.7746688274
Sum	1961237
Variance	675.6413463

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
102	1690	6.5%
101	1591	6.1%
93	1437	5.5%
100	1218	4.7%
99	969	3.7%
98	757	2.9%
97	643	2.5%
96	594	2.3%
95	560	2.1%
94	483	1.8%
Other values (83)	16206	62.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	4	< 0.1%
12	11	< 0.1%
13	36	0.1%
14	36	0.1%
15	61	0.2%

Value	Count	Frequency (%)
103	170	0.7%
102	1690	6.5%
101	1591	6.1%
100	1218	4.7%
99	969	3.7%

WindDirection(Degrees)
Real number (ℝ_≥0)

Distinct count	15777
Unique (%)	60.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	143.25996978736424
Minimum	0.09
Maximum	359.95
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	0.09
5-th percentile	16.937
Q1	81.9775
median	147.645
Q3	179.22
95-th percentile	323.3665
Maximum	359.95
Range	359.86
Interquartile range (IQR)	97.2425

Descriptive statistics

Standard deviation	82.98817746
Coefficient of variation (CV)	0.5792837844
Kurtosis	0.2319634337
Mean	143.2599698
Median Absolute Deviation (MAD)	42.37
Skewness	0.5628664262
Sum	3745961.69
Variance	6887.037597

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.11	76	0.3%
359.93	49	0.2%
359.92	39	0.1%
0.1	31	0.1%
0.12	29	0.1%
85.39	17	0.1%
191.13	12	< 0.1%
359.91	12	< 0.1%
25.99	12	< 0.1%
177.56	12	< 0.1%
Other values (15767)	25859	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09	2	< 0.1%
0.1	31	0.1%
0.11	76	0.3%
0.12	29	0.1%
0.13	8	< 0.1%

Value	Count	Frequency (%)
359.95	1	< 0.1%
359.94	3	< 0.1%
359.93	49	0.2%
359.92	39	0.1%
359.91	12	< 0.1%

Speed
Real number (ℝ_≥0)

ZEROS

Distinct count	36
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.248521493039621
Minimum	0.0
Maximum	39.37
Zeros	375
Zeros (%)	1.4%
Memory size	204.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1.12
Q1	3.37
median	5.62
Q3	7.87
95-th percentile	12.37
Maximum	39.37
Range	39.37
Interquartile range (IQR)	4.5

Descriptive statistics

Standard deviation	3.484165777
Coefficient of variation (CV)	0.5575984304
Kurtosis	6.910850573
Mean	6.248521493
Median Absolute Deviation (MAD)	2.25
Skewness	1.499486136
Sum	163386.34
Variance	12.13941116

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5.62	3680	14.1%
4.5	3612	13.8%
6.75	3482	13.3%
3.37	3093	11.8%
7.87	2858	10.9%
2.25	2201	8.4%
9	2035	7.8%
10.12	1374	5.3%
1.12	1102	4.2%
11.25	865	3.3%
Other values (26)	1846	7.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	375	1.4%
1.12	1102	4.2%
2.25	2201	8.4%
3.37	3093	11.8%
4.5	3612	13.8%

Value	Count	Frequency (%)
39.37	1	< 0.1%
38.25	2	< 0.1%
37.12	2	< 0.1%
36	3	< 0.1%
34.87	3	< 0.1%

TimeSunRise
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	51
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

06:11:00	1116
06:08:00	1065
06:10:00	924
06:13:00	921
06:12:00	912
Other values (46)	21210

Value	Count	Frequency (%)
06:11:00	1116	4.3%
06:08:00	1065	4.1%
06:10:00	924	3.5%
06:13:00	921	3.5%
06:12:00	912	3.5%
06:16:00	898	3.4%
06:14:00	889	3.4%
06:09:00	824	3.2%
06:56:00	690	2.6%
06:23:00	686	2.6%
Other values (41)	17223	65.9%

Length

Max length	8
Mean length	8
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

TimeSunSet
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	56
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

17:42:00	2961
17:43:00	1829
17:44:00	1491
17:46:00	1391
17:45:00	1140
Other values (51)	17336

Value	Count	Frequency (%)
17:42:00	2961	11.3%
17:43:00	1829	7.0%
17:44:00	1491	5.7%
17:46:00	1391	5.3%
17:45:00	1140	4.4%
17:47:00	935	3.6%
17:51:00	925	3.5%
17:48:00	923	3.5%
17:49:00	911	3.5%
17:54:00	908	3.5%
Other values (46)	12734	48.7%

Length

Max length	8
Mean length	8
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	90.9%
Other_Punctuation	1	9.1%

Value	Count	Frequency (%)
Common	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

Radiation
Real number (ℝ_≥0)

Distinct count	11826
Unique (%)	45.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	208.04478048034267
Minimum	1.13
Maximum	1601.26
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	1.13
5-th percentile	1.19
Q1	1.23
median	2.71
Q3	358.945
95-th percentile	905.965
Maximum	1601.26
Range	1600.13
Interquartile range (IQR)	357.715

Descriptive statistics

Standard deviation	316.0902472
Coefficient of variation (CV)	1.519337551
Kurtosis	0.4816721632
Mean	208.0447805
Median Absolute Deviation (MAD)	1.53
Skewness	1.358960261
Sum	5439954.92
Variance	99913.04436

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1.22	1751	6.7%
1.23	1692	6.5%
1.21	1623	6.2%
1.24	1357	5.2%
1.2	1247	4.8%
1.25	949	3.6%
1.19	773	3.0%
1.26	586	2.2%
1.18	385	1.5%
1.27	367	1.4%
Other values (11816)	15418	59.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.13	3	< 0.1%
1.14	4	< 0.1%
1.15	35	0.1%
1.16	68	0.3%
1.17	176	0.7%

Value	Count	Frequency (%)
1601.26	1	< 0.1%
1475.4	1	< 0.1%
1451.41	1	< 0.1%
1410.52	1	< 0.1%
1387.17	1	< 0.1%

Year
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

2016	26148

Value	Count	Frequency (%)
2016	26148	100.0%

Length

Max length	4
Mean length	4
Min length	4

Value	Count	Frequency (%)
Decimal_Number	4	100.0%

Value	Count	Frequency (%)
Common	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

Month
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

10	6995
11	6657
12	6527
9	5969

Value	Count	Frequency (%)
10	6995	26.8%
11	6657	25.5%
12	6527	25.0%
9	5969	22.8%

Length

Max length	2
Mean length	1.771722503
Min length	1

Value	Count	Frequency (%)
Decimal_Number	4	100.0%

Value	Count	Frequency (%)
Common	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

Day
Real number (ℝ_≥0)

Distinct count	31
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.828935291418082
Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Memory size	204.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.706177276
Coefficient of variation (CV)	0.5500166066
Kurtosis	-1.171341809
Mean	15.82893529
Median Absolute Deviation (MAD)	7
Skewness	-0.06613776473
Sum	413895
Variance	75.79752276

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
23	947	3.6%
2	937	3.6%
22	931	3.6%
27	931	3.6%
19	929	3.6%
18	919	3.5%
14	915	3.5%
17	913	3.5%
3	913	3.5%
20	912	3.5%
Other values (21)	16901	64.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	875	3.3%
2	937	3.6%
3	913	3.5%
4	908	3.5%
5	873	3.3%

Value	Count	Frequency (%)
31	436	1.7%
30	456	1.7%
29	886	3.4%
28	907	3.5%
27	931	3.6%

Hour
Real number (ℝ_≥0)

ZEROS

Distinct count	24
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.523022793330274
Minimum	0
Maximum	23
Zeros	1003
Zeros (%)	3.8%
Memory size	204.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6
median	12
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.917195806
Coefficient of variation (CV)	0.6002935107
Kurtosis	-1.209506317
Mean	11.52302279
Median Absolute Deviation (MAD)	6
Skewness	0.001670671384
Sum	301304
Variance	47.84759782

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13	1134	4.3%
2	1118	4.3%
4	1113	4.3%
3	1111	4.2%
22	1107	4.2%
1	1103	4.2%
6	1101	4.2%
14	1101	4.2%
20	1101	4.2%
8	1098	4.2%
Other values (14)	15061	57.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1003	3.8%
1	1103	4.2%
2	1118	4.3%
3	1111	4.2%
4	1113	4.3%

Value	Count	Frequency (%)
23	1094	4.2%
22	1107	4.2%
21	1083	4.1%
20	1101	4.2%
19	1096	4.2%

Minute
Real number (ℝ_≥0)

ZEROS

Distinct count	26
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27.522755086431086
Minimum	0
Maximum	57
Zeros	2158
Zeros (%)	8.3%
Memory size	204.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	15
median	30
Q3	41
95-th percentile	55
Maximum	57
Range	57
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	17.25434808
Coefficient of variation (CV)	0.626912096
Kurtosis	-1.214326679
Mean	27.52275509
Median Absolute Deviation (MAD)	15
Skewness	-0.002075381756
Sum	719665
Variance	297.7125277

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
35	2194	8.4%
50	2165	8.3%
40	2161	8.3%
25	2159	8.3%
0	2158	8.3%
10	2156	8.2%
30	2143	8.2%
15	2140	8.2%
55	2139	8.2%
5	2132	8.2%
Other values (16)	4601	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2158	8.3%
1	29	0.1%
2	1	< 0.1%
5	2132	8.2%
6	29	0.1%

Value	Count	Frequency (%)
57	3	< 0.1%
56	30	0.1%
55	2139	8.2%
51	33	0.1%
50	2165	8.3%

Second
Real number (ℝ_≥0)

Distinct count	60
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.44752944775891
Minimum	0
Maximum	59
Zeros	2
Zeros (%)	< 0.1%
Memory size	204.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	18
Q3	22
95-th percentile	49
Maximum	59
Range	59
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.91335632
Coefficient of variation (CV)	0.7401252057
Kurtosis	0.557898701
Mean	17.44752945
Median Absolute Deviation (MAD)	7
Skewness	0.8325560576
Sum	456218
Variance	166.7547715

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
18	3040	11.6%
2	2603	10.0%
20	2131	8.1%
17	1838	7.0%
21	1714	6.6%
19	1362	5.2%
4	1357	5.2%
1	1325	5.1%
22	1152	4.4%
5	1116	4.3%
Other values (50)	8510	32.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	1325	5.1%
2	2603	10.0%
3	945	3.6%
4	1357	5.2%

Value	Count	Frequency (%)
59	8	< 0.1%
58	16	0.1%
57	16	0.1%
56	32	0.1%
55	44	0.2%

SunPerDay
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	75
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

0 days 10:56:00	3242
0 days 10:57:00	1811
0 days 11:22:00	472
0 days 11:12:00	471
0 days 11:00:00	471
Other values (70)	19681

Value	Count	Frequency (%)
0 days 10:56:00	3242	12.4%
0 days 10:57:00	1811	6.9%
0 days 11:22:00	472	1.8%
0 days 11:12:00	471	1.8%
0 days 11:00:00	471	1.8%
0 days 11:04:00	470	1.8%
0 days 11:37:00	468	1.8%
0 days 11:34:00	468	1.8%
0 days 11:07:00	467	1.8%
0 days 11:08:00	467	1.8%
Other values (65)	17341	66.3%

Length

Max length	15
Mean length	15
Min length	15

Value	Count	Frequency (%)
Decimal_Number	10	62.5%
Lowercase_Letter	4	25.0%
Space_Separator	1	6.2%
Other_Punctuation	1	6.2%

Value	Count	Frequency (%)
Common	12	75.0%
Latin	4	25.0%

Value	Count	Frequency (%)
ASCII	16	100.0%

SunPerDayHours
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	204.4 KiB

11	17051
12	9097

Value	Count	Frequency (%)
11	17051	65.2%
12	9097	34.8%

Length

Max length	2
Mean length	2
Min length	2

Value	Count	Frequency (%)
Decimal_Number	2	100.0%

Value	Count	Frequency (%)
Common	2	100.0%

Value	Count	Frequency (%)
ASCII	2	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	Id	UNIXTime	Data	Time	Temperature	Pressure	Humidity	WindDirection(Degrees)	Speed	TimeSunRise	TimeSunSet	Radiation	Year	Month	Day	Hour	Minute	Second	SunPerDay	SunPerDayHours
0	4152	1473879005	9/14/2016 12:00:00 AM	08:50:05	57	30.45	68	26.70	4.50	06:10:00	18:26:00	680.04	2016	9	14	8	50	5	0 days 12:16:00	12
1	13047	1476293121	10/12/2016 12:00:00 AM	07:25:21	50	30.47	96	144.96	10.12	06:16:00	18:02:00	277.37	2016	10	12	7	25	21	0 days 11:46:00	12
2	7420	1477993220	10/31/2016 12:00:00 AM	23:40:20	47	30.48	56	119.52	3.37	06:23:00	17:49:00	1.29	2016	10	31	23	40	20	0 days 11:26:00	11
3	6508	1473013505	9/4/2016 12:00:00 AM	08:25:05	57	30.47	93	38.61	2.25	06:08:00	18:35:00	544.75	2016	9	4	8	25	5	0 days 12:27:00	12
4	29110	1481885434	12/16/2016 12:00:00 AM	00:50:34	41	30.23	103	177.55	2.25	06:50:00	17:46:00	1.22	2016	12	16	0	50	34	0 days 10:56:00	11
5	25348	1483015543	12/29/2016 12:00:00 AM	02:45:43	37	30.35	54	177.00	6.75	06:56:00	17:53:00	1.15	2016	12	29	2	45	43	0 days 10:57:00	11
6	13599	1476124823	10/10/2016 12:00:00 AM	08:40:23	60	30.44	47	4.88	1.12	06:16:00	18:03:00	578.60	2016	10	10	8	40	23	0 days 11:47:00	12
7	20795	1479113702	11/13/2016 12:00:00 AM	22:55:02	45	30.47	83	114.39	6.75	06:30:00	17:44:00	1.20	2016	11	13	22	55	2	0 days 11:14:00	11
8	28143	1482176417	12/19/2016 12:00:00 AM	09:40:17	53	30.53	84	154.09	7.87	06:52:00	17:48:00	269.53	2016	12	19	9	40	17	0 days 10:56:00	11
9	15824	1475442321	10/2/2016 12:00:00 AM	11:05:21	57	30.47	99	40.61	1.12	06:14:00	18:10:00	942.25	2016	10	2	11	5	21	0 days 11:56:00	12

Last rows

	Id	UNIXTime	Data	Time	Temperature	Pressure	Humidity	WindDirection(Degrees)	Speed	TimeSunRise	TimeSunSet	Radiation	Year	Month	Day	Hour	Minute	Second	SunPerDay	SunPerDayHours
26138	6265	1473089111	9/5/2016 12:00:00 AM	05:25:11	47	30.40	73	179.01	7.87	06:08:00	18:35:00	2.69	2016	9	5	5	25	11	0 days 12:27:00	12
26139	22118	1478716805	11/9/2016 12:00:00 AM	08:40:05	54	30.46	51	337.08	2.25	06:28:00	17:45:00	484.33	2016	11	9	8	40	5	0 days 11:17:00	11
26140	11284	1476831318	10/18/2016 12:00:00 AM	12:55:18	58	30.41	98	350.19	9.00	06:18:00	17:57:00	556.69	2016	10	18	12	55	18	0 days 11:39:00	11
26141	11964	1476625223	10/16/2016 12:00:00 AM	03:40:23	50	30.49	24	158.70	5.62	06:18:00	17:59:00	1.19	2016	10	16	3	40	23	0 days 11:41:00	11
26142	21575	1478879702	11/11/2016 12:00:00 AM	05:55:02	46	30.47	36	180.23	6.75	06:29:00	17:44:00	1.23	2016	11	11	5	55	2	0 days 11:15:00	11
26143	29802	1481676309	12/13/2016 12:00:00 AM	14:45:09	50	30.28	96	304.22	12.37	06:48:00	17:45:00	216.29	2016	12	13	14	45	9	0 days 10:57:00	11
26144	5390	1473426025	9/9/2016 12:00:00 AM	03:00:25	44	30.37	100	162.80	3.37	06:09:00	18:31:00	1.47	2016	9	9	3	0	25	0 days 12:22:00	12
26145	860	1474966519	9/26/2016 12:00:00 AM	22:55:19	48	30.42	64	158.90	4.50	06:12:00	18:15:00	1.20	2016	9	26	22	55	19	0 days 12:03:00	12
26146	15795	1475451021	10/2/2016 12:00:00 AM	13:30:21	56	30.42	99	55.72	13.50	06:14:00	18:10:00	659.12	2016	10	2	13	30	21	0 days 11:56:00	12
26147	23654	1478255721	11/4/2016 12:00:00 AM	00:35:21	45	30.45	56	136.11	5.62	06:25:00	17:47:00	1.18	2016	11	4	0	35	21	0 days 11:22:00	11

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows